package com.bbcare.oms.plat.store.ibatis;

import com.bbcare.oms.plat.entity.AuHospital;
import com.bbcare.oms.plat.entity.AuTenantDeptRel;
import java.util.List;
import org.apache.ibatis.annotations.CacheNamespace;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;

@CacheNamespace(readWrite=true)
public abstract interface IAuHospitalDAO
{
  @Select({"select * from au_tenant_dept_rel a where a.tenant_id = #{tenantId} and a.status = #{status}"})
  @Results({@org.apache.ibatis.annotations.Result(property="relationId", column="relation_id"), @org.apache.ibatis.annotations.Result(property="relationType", column="relation_type")})
  public abstract List<AuTenantDeptRel> selectTenantDeptRel(@Param("tenantId") String paramString1, @Param("status") String paramString2)
    throws Exception;
  
  @Select({"select a.* from au_hospital a where a.id = #{hospital} "})
  @Results({@org.apache.ibatis.annotations.Result(property="hospitalShortName", column="hospital_short_name"), @org.apache.ibatis.annotations.Result(property="hospitalName", column="hospital_name"), @org.apache.ibatis.annotations.Result(property="imageUrl", column="image_url"), @org.apache.ibatis.annotations.Result(property="iconUrl", column="icon_url")})
  public abstract AuHospital selectHospital(@Param("hospital") String paramString)
    throws Exception;
  
  @Select({"select a.* from au_hospital a where a.id in(select b.hospital_id from au_department b where b.id = #{departmentId}) "})
  @Results({@org.apache.ibatis.annotations.Result(property="hospitalShortName", column="hospital_short_name"), @org.apache.ibatis.annotations.Result(property="hospitalName", column="hospital_name"), @org.apache.ibatis.annotations.Result(property="imageUrl", column="image_url"), @org.apache.ibatis.annotations.Result(property="iconUrl", column="icon_url")})
  public abstract AuHospital qryHospitalInfoByDepartmentId(@Param("departmentId") String paramString)
    throws Exception;
}


/* Location:              C:\Users\ZCL\Desktop\oms\oms\oms\WEB-INF\classes\com.zip!\com\bbcare\oms\plat\store\ibatis\IAuHospitalDAO.class
 * Java compiler version: 7 (51.0)
 * JD-Core Version:       0.7.1
 */